﻿<html DIR="LTR" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ddue="http://ddue.schemas.microsoft.com/authoring/2003/5" xmlns:MSHelp="http://msdn.microsoft.com/mshelp">
  <head>
    <META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=utf-8" />
    <META NAME="save" CONTENT="history" />
    <title>Readme for Aggregation Manager Sample</title>
    
 <Style TYPE="text/css">

body
{
    background: #FFFFFF;
    color: #000000;
    font-family:    Verdana;
    font-size: medium;
    font-style: normal;
    font-weight: normal;
    margin-top: 0;
    margin-bottom:  0;
    margin-left:    0;
    margin-right:   0;
    width:  100%;
}

div.#mainSection
{
    font-size: 70%;
    width: 100%;
    padding-left:    10;
    margin-right: 10;
}

div.#mainBody
{
    font-size: 90%;
    margin-top: 10;
    padding-bottom: 20;
}

div.#header
{
    background-color: #D2D2D2;
    padding-top:    0;
    padding-bottom: 0;
    padding-left:   10;
    padding-right:  0;
    width:          100%;
}

div.#header table
{
    border-bottom-color: #C8CDDE;
    border-bottom-style: solid;
    border-bottom-width: 1;
    width:  100%;
}

span.#runningHeaderText
{
    color: #003399;
    font-size: 90%;
}

span.#nsrTitle
{
/*    color: #003399;*/
    font-size: 120%;
    font-weight: 600;
}

div.#header table td
{
    color: #000000;
    font-size: 70%;
    margin-top: 0;
    margin-bottom:  0;
    padding-right: 20;
}

div.#header table tr.#headerTableRow3 td
{
    padding-bottom: 2;
    padding-top: 5;
}

div.#header table.#bottomTable
{
    border-top-color: #FFFFFF;
    border-top-style: solid;
    border-top-width: 1;
    text-align: left;
}

div.#footer
{
    font-size: 90%;
    margin-top: 0;
    margin-bottom:  0;
    margin-left:    -5;
    margin-right:   0;
    padding-top:    2;
    padding-bottom: 2;
    padding-left:   0;
    padding-right:  0;
    width:  100%;
}

hr.#footerHR
{
    border-bottom-color: #EEEEFF;
    border-bottom-style: solid;
    border-bottom-width: 1;
    border-top-color: C8CDDE;
    border-top-style: solid;
    border-top-width: 1;
    height: 3;
    color: #D2D2D2;
}

div.section
{
    padding-top:    2;
    padding-bottom: 2;
    padding-right:  15;
    width:  100%;
}

.heading
{
    color:          #000000;
    font-weight:    bold;
    margin-top:     18;
    margin-bottom:  8;
}

h1.heading
{
    color: #000000;
    font-size:  150%;
}

.subHeading
{
    color:          #000000;
    font-weight:    bold;
    font-size:      150%;
    margin-bottom:  4;
}

h2.subHeading
{
    color:          #000000;
    font-weight:    bold;
    font-size:      130%;
}
h3.subHeading
{
    color:  #000000;
    font-size: 125%;
    font-weight: bold;
}

h4.subHeading
{
    color: #000000;
    font-size: 110%;
    font-weight: bold;
}

h4.procedureHeading
{
    color: #000080;
    font-size: 110%;
    font-weight: bold;
}

h5.subHeading
{
    color: #000000;
    font-size: 100%;
    font-weight: bold;
}

img
{
    padding-bottom: 10;
}

img.toggle
{
    border: 0;
    margin-right: 5;
    padding-bottom: 10;
}

img.copyCodeImage
{
    border: 0;
    margin: 1;
    margin-right: 3;
    padding-bottom: 10;
}

img.downloadCodeImage
{
    border: 0;
    margin-right: 3;
    padding-bottom: 10;
}

img.viewCodeImage
{
    border: 0;
    margin-right: 3;
    padding-bottom: 10;
}

img.note
{
    border: 0;
    margin-right: 3;
    padding-bottom: 10;
}

img.#membersOptionsFilterImage
{
    border: 0;
    margin-left: 10;
    vertical-align: middle;
    padding-bottom: 10;
}

img.#toggleAllImage
{
    margin-left: 4;
    vertical-align: middle;
    padding-bottom: 10;
}

div.#mainSection table
{
    border: 0;
    font-size: 100%;
    width:  100%;
    margin-top: 5px;
    margin-bottom: 15px;
}

div.#mainSection table tr
{
    vertical-align: top;
}

div.#mainSection table th
{
    text-align: left;
    background: #D8D8D8;
    border-bottom-color: #D8D8D8;
    border-bottom-style: solid;
    border-bottom-width: 1;
    color: #000000;
    padding-left: 5;
    padding-right: 5;
}

div.#mainSection table td
{
    background: #F2F2F2;
    border-top-color: #D8D8D8;
    border-top-style: solid;
    border-top-width: 1;
    padding-left: 5;
    padding-right: 5;
}

div.#mainSection table td.imageCell
{
    white-space: nowrap;
}

div.code
{
	width: 98%;
}

div.code table
{
    border: 0;
    font-size: 95%;
    margin-bottom: 5;
    width: 100%
}

div.code table th
{   
    text-align: left;
    background: #D8D8D8;
    border-bottom-color: #D8D8D8;
    border-bottom-style: solid;
    border-bottom-width: 1;
    color: #000000;
    font-weight: bold;
    padding-left: 5;
    padding-right: 5;
}

div.code table td
{
    background: #CCCCCC;
    border-top-color: #D8D8D8;
    border-top-style: solid;
    border-top-width: 1;
    padding-left: 5;
    padding-right: 5;
    padding-top: 5;
}

div.alert
{
	margin-left: 10;
	width: 98%;
}

div.alert table
{
    border: 1;
    font-size: 100%;
    width:  100%;
    border: solid 1 #DEDFEF;
}

div.alert table th
{
    text-align: left;
    background: #D8D8D8;
    border-bottom-width: 0;
    color: #000000;
    padding-left: 5;
    padding-right: 5;
    border: solid 1 #DEDFEF;
}

div.alert table td
{
    background: #FFFFFF;
    border-top-color: #D8D8D8;
    border-top-style: solid;
    border-top-width: 1;
    padding-left: 5;
    padding-right: 5;
    border: solid 1 #DEDFEF;
}

span.copyCode
{
    color: #0000ff;
    font-size: 90%;
    font-weight: normal;
    cursor: hand;
    float: right;
    display: inline;
    text-align: right;
}

.downloadCode
{
    color: #0000ff;
    font-size: 90%;
    font-weight: normal;
    cursor: hand;
}

.viewCode
{
    color: #0000ff;
    font-size: 90%;
    font-weight: normal;
    cursor: hand;
}

div.code pre
{
    font-family:    Monospace, Courier New, Courier;
    font-size: 105%;
    color:  #000000;
}

code
{
    font-family:    Monospace, Courier New, Courier;
    font-size: 105%;
    color:  #000000;
}

dl
{
    margin-top: 0;
    padding-left:   1;
}

dd
{
    margin-bottom:  0;
    margin-left:    0;
    padding-left:   20;
}

dd p
{
    margin-top: 5;
}

ul
{
    margin-left: 17;
    list-style-type: disc;
}

ul ul
{
    margin-bottom: 4;
    margin-left: 17;
    margin-top: 3;
    list-style-type: disc;
}

ol
{
    margin-left: 24;
    list-style-type: decimal;
}

ol ol
{
    margin-left: 24;
    margin-top: 3;
    list-style-type: lower-alpha;
}

li
{
    margin-top: 0;
    margin-bottom: 0;
    padding-bottom: 0;
    padding-top: 0;
    margin-left: 5;
}

p
{
    margin-bottom: 15;
}

.tip
{
    color:  #0000FF;
    font-style: italic;
    cursor:hand;
    text-decoration:underline;
}

.math
{
    font-family: Times New Roman;
    font-size: 125%
}
.sourceCodeList
{
    font-family: Verdana;
    font-size: 90%; 
}

pre.viewCode
{
    width: 100%;
    overflow: auto;
}

li:hover table, li.over table
{
    background-color: #C0C0C0;
}

li:hover ul, li.over ul
{ 
    background-color: #d2d2d2;
    border: 1px solid #000;
    display: block;
}

</style>
  </head>
  <body>
    <!--Topic built:1/19/2007-->

    <div id="header">
      <table width="100%" id="topTable">
        <tr>
          <td align="left">
            <span id="nsrTitle">Readme for Aggregation Manager Sample</span>
          </td>
          <td align="right">
            <span id="headfb" class="feedbackhead">
            </span>
          </td>
        </tr>
        <tr id="headerTableRow3">
          <td />
          <td align="right">
          </td>
        </tr>
      </table>
      </div>
    <div id="mainSection">
      <div id="mainBody">

        <font color="DarkGray"> </font><p /> 
        <span id="changeHistory">
        </span>
    <p>Aggregation Manager is a sample application that lets you view, design, edit, and add aggregations based on the information collected in the query log.</p>
  <h1 class="heading">Scenario</h1><div id="sectionSection0" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The Aggregation Manager sample illustrates how to take advantage of various SQL Server 2005 Analysis Services features to handle aggregation design.</p>
      <p xmlns="">The sample can connect to an instance of Analysis Services and display a set of aggregation designs. It also displays the partitions that the aggregation design is applied to.</p>
      <p xmlns="">You can use the sample to display a set of aggregations in a particular aggregation design, and to change each aggregation as you want. Aggregation designs can be applied to any partition in the measure group.</p>
      <p xmlns="">You run the sample and connect to the query log table to import statistical information about Multidimensional Expressions (MDX) queries, to display the MDX queries, and to add new aggregations based on the displayed set.</p>
    </content></div><h1 class="heading">Languages</h1><div id="sectionSection1" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">C# (using the AMO object model)</p>
    </content></div><h1 class="heading">Features</h1><div id="sectionSection2" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">The Aggregation Manager sample uses the following new features of SQL Server 2005 Analysis Services. </p>
      <h3 class="subHeading" xmlns=""></h3><table width="100%" cellspacing="0" cellpadding="0" border="1" style="background-color: #CCCCCC;" xmlns=""><tr>
            <th>
              Application Area
            </th>
            <th>
              Features
            </th>
          </tr><tr>
          <td>
            <p>Add, delete, and change existing aggregations</p>
          </td>
          <td>
            <p>Use of AggregationDesign and Aggregation objects in AMO to manage aggregations.</p>
          </td>
        </tr><tr>
          <td>
            <p>Create XMLA scripts</p>
          </td>
          <td>
            <p>Use Scripter AMO objects to serialize Analysis Services objects and creating XML for Analysis (XMLA) scripts.</p>
          </td>
        </tr><tr>
          <td>
            <p>Using QueryLog as source for the new aggregations</p>
          </td>
          <td>
            <p>Connecting to the SQL Server database and presenting set of aggregations. Adding new aggregations based on the query log. </p>
          </td>
        </tr></table>
    </content></div><h1 class="heading">Prerequisites</h1><div id="sectionSection3" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Before you run this sample:</p>
      <ol xmlns=""><li>
          Make sure that the following software is installed on the developer's computer:<br></br>
          <ul><li>
              Visual Studio 2005 with C# compiler or .Net Framework 2.0 SDK<br></br>
            </li><li>
              
                SQL Server 2005 SP2 samples are installed<br></br>
            </li></ul>
        </li><li>
          Make sure that the following services are started and available either in the local computer or another that you can administer:<br></br>
          <ul><li>
              
                SQL Server Analysis Services<br></br>
            </li><li>
              
                SQL Server engine<br></br>
            </li></ul>
        </li><li>
          Make sure that you have a signature file that is named AggManager.snk. To create a signature file follow the steps at <a href="http://msdn2.microsoft.com/en-us/library/k5b5tt23(VS.71).aspx" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Strong Name Tool (Sn.exe)</linkText></a><br></br>
        </li><li>
          Configure Analysis Services to log queries, see <a href="http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/config_ssas_querylog.mspx" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Configuring the Analysis Services Query Log</linkText></a>. Set the <i>QueryLogSampling</i> value to 1.<br></br>
        </li><li>
          Make sure that you have run some queries against a cube you want to design aggregations on. If you do not have a suitable cube to run queries on, you can deploy the <i>Adventure Works DW</i> database and use the Adventure Works cube as a test case; see <a href="http://msdn2.microsoft.com/en-us/library/ms143804.aspx" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">Running Setup to Install </linkText></a>.<br></br>
        </li></ol>
    </content></div><h1 class="heading">Building the Sample</h1><div id="sectionSection4" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <procedure>
        Option 1: To build the sample by using Visual Studio
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Locate the folder where the solution file AggManager.sln is stored.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Move the signature file AggManager.snk to the solution folder.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open Visual Studio.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the <b>Recent Projects</b> tab, at the bottom where it says <b>Open</b>, click <b>Project</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open the folder where you saved the file AggManager.sln, select the file, and then click <b>Open</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Press <b>F6</b> to build the project.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">
              </p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
      <procedure>
        Option 2: To build the sample by using msbuild.exe from .Net Framework SDK
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Locate the folder where the solution file AggManager.sln is stored.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Move the signature file AggManager.snk to the solution folder.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open a command prompt and change directory to the location where the solution file is located. Configure the environment according to the specifications in <a href="http://msdn2.microsoft.com/en-us/library/ms172492.aspx" alt=""><linkText xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">How to: Compile at the Command Prompt</linkText></a>. </p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Type <b>msbuild.exe AggManager.sln</b> and press Enter.</p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
    </content></div><h1 class="heading">Running the Sample</h1><div id="sectionSection5" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <p xmlns="">Before you run the sample you should have some query logs recorded in an SQL table; see prerequisites 4 and 5. </p>
      <procedure>
        Step 1: To connect to Analysis Services
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Start the sample either by pressing <b>F5</b> or <b>CTRL+F5</b> in Visual Studio with <i>AggManager.sln</i> opened, or by typing <b>AggManager.exe</b> and pressing Enter in a Command Prompt window opened where the executable file is located.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">If you are connecting to the same server where you are running the executable, and the instance you are using is the default instance then you can leave <i>localhost</i> as is and click the <b>Connect</b> button. If you are connecting to a different server or a named instance, then you must replace <i>localhost</i> with the correct <i>Server Name</i> or <i>&lt;Server Name&gt;\&lt;Instance&gt;</i> value and then click the <b>Connect</b> button.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the treeview of the server and check that you can browse the databases, cubes, and other available objects.</p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
      <procedure>
        Step 2: To connect to the query log
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Connect to Analysis Services if you are not yet connected, see Step 1.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the server object by clicking the <b>+</b> next to the server name, then and expand the <b>Databases</b> folder object.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the database object that contains the cubes where you ran the queries that are logged, then expand the <b>Cubes</b> folder object.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the cube object where the queries were run and are logged, then expand the <b>Measure Groups</b> folder object.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand a measure group object where you want aggregations to be analyzed and designed.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Right-click the <b>No Aggregation Design</b> folder object and select <b>Add from query log</b>. A new window opens.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Read the dimmed connection string in <b>QL Server Connect</b> text box. </p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
      <procedure>
        Step 3: Creating new aggregation design, deleting aggregation design, associating aggregation design with partitions
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To start creating new aggregation designs you must be connected to the query log database, see previous step.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">In the <b>Add Aggregations from Query Log</b> window, assign a name to <b>Aggregation Design Name</b> and <b>Aggregation Prefix</b>. <b>Aggregation Design Name</b> is the base name of these current set of aggregations designs. <b>Aggregation Prefix</b> is the specific name of the new aggregation design that will be created.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">If no records are available in the datagrid, click <b>Execute SQL</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click <b>OK</b> to create the new aggregation design and return to the <b>Aggregation Manager</b> window. Clicking <b>Cancel</b> will cancel current action, close the window, and return you to the Aggregation Manager window.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">The newly created aggregation design now appears as part of the expanded node.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To delete one aggregation design, right-click the aggregation design and select <b>delete</b> on the shortcut menu.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To associate a partition to an aggregation design, right-click the intended design node and select <b>Change Partitions</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the partitions windows, select the desired partitions to be assigned to the intended design, and then click <b>OK</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Expand the node and the partitions should now appear under the design.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">
              </p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
      <procedure>
        Step 4: Editing aggregation design, viewing aggregation definition
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select the aggregation design you want to edit. If the right pane says <b>Aggregation count</b> with no value, then the design has no aggregations designed; follow the next steps to start a new aggregation design. If there are already aggregations designed, you can skip to number 8 and continue from there editing.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Right-click the aggregation design and select <b>Add from query log</b> on the shortcut menu opened.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Verify the connection string and adjust it accordingly.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Add Name and Prefix to this design.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the <b>Execute SQL</b> button.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">If the query returned only one record with zeros and commas only then copy that record to the clipboard.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Click the <b>OK</b> button; a message box with <b>Aggregation Design '</b><i>&lt;Your Aggregation Design Name here</i><b>&gt;' updated with </b><i>n</i><b> aggregations</b> appears.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select the aggregation design you want to edit, right-click it and select <b>Edit</b> on the shortcut menu.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">If an empty datatgrid appears, you will need the string stored in the clipboard from numbers 2 to 7. Click the row under the <b>Name</b> column and write the name for this design; click the row under <b>Aggregation Definition</b> and paste the row of zeros and commas from clipboard; click under <b>Type</b> and write <i>Flexible</i>. Press <b>TAB</b> key to move to a new row. You now have an empty design created.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Select a row from the datagrid. You will know what row is selected by the little icon that appears to the left of the row. If a group of rows is selected only the row with the icon will be updated.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">On the right pane appears the collection of all dimensions defined for the current measure group as a set of Trees. Each top node represents a dimension; checking or un-checking the dimension node has no effect on the aggregation design. Make sure that you have Show Attribute Relationships selected; it is located exactly below the title bar of the window. The tree structure represents the attribute relationship starting from the key attribute as the first node level; next level of attributes are those that directly depend on the key or those that are directly related to the key; next level will contain attributes directly related to the father attribute by an attribute relationship definition and similar for the descendant levels. The string of zeros, ones and commas is a map representation of the dimensions tree structure. The comma character is the dimensions separator; zeros and ones represent each a dimension attribute. The string maps left to right the nodes top to down; each selected dimension attribute node appears in the string as a 1 and those unselected appears as a 0 in the string. The lowers levels of granularity are those closer to the top of the tree.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To modify a design you have to select or unselect nodes in the right pane, for a given row, and changes will be reflected in the string; working on the string will also be reflected on the tree structure.</p>
            </content>
          </li></ol></ddue:steps>
        <conclusion>
          <content>
            <div class="alert" xmlns=""><table width="100%" cellspacing="0" cellpadding="0"><tr><th align="left">Note: </th></tr><tr><td>
              Shortening the length of the string will make the application to crash.<p></p>
            </td></tr></table><p></p></div>
            <ol xmlns=""><li>
                Once you are done with your edits you can press <b>OK</b> to save work.<br></br>
              </li><li>
                Your work is saved in memory but has not been applied to the server. You can distinguish which designs are pending to be applied to the servers by the suffix <b> modified</b> appended to the measure group name.<br></br>
              </li><li>
                To save your changes to the server right-click on the measure group and select <b>Save to server</b>.<br></br>
              </li></ol>
          </content>
        </conclusion>
      </procedure>
      <procedure>
        Step 5: Eliminating redundant attributes from the aggregations in the aggregation design
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open an <b>Edit Aggregations Aggregation Design</b> window by right-clicking on the design node and selecting <b>Edit</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To eliminate redundant attributes from and aggregation design click the <b>Eliminate Redundancy</b> button. This will remove all attributes that are redundant in the current design; leaving the design with fewer attributes but the significant ones.</p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
      <procedure>
        Step 6: Eliminating duplicate aggregations
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Open an <b>Edit Aggregations Aggregation Design</b> window by right-clicking on the design node and selecting <b>Edit</b>.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">To eliminate duplicate designs from and aggregation design, click the <b>Eliminate Duplicates</b> button. This will remove all duplicated rows from the current design; leaving the design with fewer rows but the significant ones.</p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
    </content></div><h1 class="heading">Removing the Sample</h1><div id="sectionSection6" class="section"><content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
      <procedure>
        To remove the Aggregation Manager sample
        <ddue:steps><ol xmlns=""><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">Delete the folder that contains the solution and all descendant folders.</p>
            </content>
          </li><li>
            <content xmlns="http://ddue.schemas.microsoft.com/authoring/2003/5">
              <p xmlns="">
              </p>
            </content>
          </li></ol></ddue:steps>
      </procedure>
    </content></div><!--[if gte IE 5]>
			<tool:tip element="seeAlsoToolTip" avoidmouse="false"/><tool:tip element="languageFilterToolTip" avoidmouse="false"/><tool:tip element="roleInfoSpan" avoidmouse="false"/>
		<![endif]--></div>
      <div id="footer">
        
			
			© 2007 Microsoft Corporation. All rights reserved.
		</a>
 	
      </div>
    </div>
  </body>
</html>